package excel.adddatatocells;
import com.aspose.cells.Cell;
import com.aspose.cells.Cells;
import com.aspose.cells.Style;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;
public class AsposeInsertCellsData
{
public static void main(String[] args) throws Exception
{
//Instantiating a Workbook object
Workbook workbook = new Workbook();
//Accessing the added worksheet in the Excel file
Worksheet worksheet = workbook.getWorksheets().get(0);
Cells cells = worksheet.getCells();
cells.get("A1").setValue("Hello World"); //Adding a string value to the cell
cells.get("A2").setValue(20.5); //Adding a double value to the cell
cells.get("A3").setValue(15); //Adding an integer value to the cell
cells.get("A4").setValue(true); //Adding a boolean value to the cell
Cell cell = cells.get("A5"); //Adding a date/time value to the cell
cell.setValue(java.util.Calendar.getInstance());
//Setting the display format of the date
Style style = cell.getStyle();
style.setNumber(15);
cell.setStyle(style);
workbook.save("data/DataInCells_Aspose.xls"); //Saving the Excel file
// Print message
System.out.println("Data Added Successfully");
}
}